Accessing More Functions

Accessing the analysis toolpak will allow you to access many additional functions in Excel.  Let’s take a look at how to access the toolpak.

Skill Builder:  Accessing the Analysis Toolpak

1.	Click	On the Tools menu.

2.	Select	Add-Ins…  If the Data Analysis option is available, 
		select this option instead.  When you select the add-ins 
		option, a dialog box will come up that will show a wide 
		variety of options.

3.	Select	The Analysis Toolpak option.

4. 	Click	OK.  Once the installation is complete, when you click 
		on the tools menu, you will see the Data Analysis option.

5. 	Select	The Data Analysis option.  This will make many 
		additional functions available to you.

An additional function you may find useful is the rand function.  To use this function, simply type =rand( and then hit enter.  This will generate random numbers.  Although this function is not part of the toolpak, there is another function, similar to this function, which is associated with the toolpak.  

The randbetween function is for use with whole numbers.  With this function you can generate random numbers between two specified end points.  For instance, if you wanted to generate random numbers between the numbers 100 and 200, you would type   =randbetween(100,200 and then hit enter.  When using this function, duplicates may occur.  To force the random numbers to change at any given time, hit F9.

Skill Builder:  Turning Off Automatic Calculations

At times you may want to turn off the automatic calculation tool in Excel.  To turn off this tool, complete the following.

1.	Select	Tools/Options.

2.	Click	On the Calculations tab.

	
3.	Select	The Manual option. 

4.	Click	OK.